Course objectives:
|
Main goal of this course is to give an overview of database installation, startup, shutdown, database initialization parameters, basic performance tuning, user management and basic security, data storage concepts, database processes overview, transaction journal, database backup and recovery basic.
|
Requirements on student
|
Credit - at least 80% point in theoretic test
and resolving simulated Oracle database failure
|
Content
|
1 Oracle database architecture, basic terms, installation
2 - 3 main database administration tasks - startup, shutdown, monitoring, basic parameters settings
4 user administration, user rights and access, security fundamentals
5 - 6 database objects, overview, characteristics
7 data processing
8 Oracle connectivity network architecture
9 - 10 performance tuning
11 - 12 database backup and recovery
13 - another tools for database administration
|
Activities
|
|
Fields of study
|
|
Guarantors and lecturers
|
|
Literature
|
|
Time requirements
|
All forms of study
|
Activities
|
Time requirements for activity [h]
|
Contact hours
|
40
|
Preparation for comprehensive test (10-40)
|
40
|
Preparation for formative assessments (2-20)
|
20
|
Total
|
100
|
|
Prerequisites
|
Knowledge - students are expected to possess the following knowledge before the course commences to finish it successfully: |
knowledge of SQL language |
knowledge of database terminology |
basic knowledge of database functioning and principles |
Skills - students are expected to possess the following skills before the course commences to finish it successfully: |
use SQL constructs |
user orientation in the Linux environment |
|
Learning outcomes
|
Knowledge - knowledge resulting from the course: |
knowledge of basic types of database failures |
knowledge scorecard database |
diagnostic knowledge database state |
Skills - skills resulting from the course: |
create and administer Oracle database |
choose optimal backup strategy |
recover Oracle database in any point-of-time |
analyze and solve basic types of database failure |
analyze and solve smaller performance problems |
Competences - competences resulting from the course: |
N/A |
N/A |
|
Assessment methods
|
Knowledge - knowledge achieved by taking this course are verified by the following means: |
Practical exam |
Test |
knowledge of basic types of database failures |
Skills - skills achieved by taking this course are verified by the following means: |
Test |
diagnostic knowledge database state |
|
Teaching methods
|
Knowledge - the following training methods are used to achieve the required knowledge: |
Lecture with visual aids |
Interactive lecture |
Laboratory work |
|